Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	198
Missing cells	482
Missing cells (%)	14.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	26.4 KiB
Average record size in memory	136.6 B

Variable types

Numeric	5
Text	7
Categorical	4
Unsupported	1

Alerts

`airdate` has constant value ""	Constant
`id_embedded` is highly overall correlated with `season`	High correlation
`season` is highly overall correlated with `id_embedded`	High correlation
`number` is highly overall correlated with `type` and 1 other fields	High correlation
`type` is highly overall correlated with `number` and 1 other fields	High correlation
`airtime` is highly overall correlated with `number` and 2 other fields	High correlation
`airstamp` is highly overall correlated with `airtime`	High correlation
`type` is highly imbalanced (94.2%)	Imbalance
`airtime` is highly imbalanced (72.6%)	Imbalance
`number` has 2 (1.0%) missing values	Missing
`runtime` has 9 (4.5%) missing values	Missing
`rating_average` has 198 (100.0%) missing values	Missing
`medium` has 94 (47.5%) missing values	Missing
`original` has 94 (47.5%) missing values	Missing
`summary` has 85 (42.9%) missing values	Missing
`id` has unique values	Unique
`url` has unique values	Unique
`_links_self` has unique values	Unique
`rating_average` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-08-06 02:45:42.149717
Analysis finished	2023-08-06 02:45:46.038389
Duration	3.89 seconds
Software version	ydata-profiling vv4.4.0
Download configuration	config.json

id
Real number (ℝ)

UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2440152.5

Minimum	2320579
Maximum	2582368
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	2320579
5-th percentile	2391975.2
Q1	2433906.2
median	2445369.5
Q3	2448947.8
95-th percentile	2503964.2
Maximum	2582368
Range	261789
Interquartile range (IQR)	15041.5

Descriptive statistics

Standard deviation	35923.596
Coefficient of variation (CV)	0.014721865
Kurtosis	5.8886687
Mean	2440152.5
Median Absolute Deviation (MAD)	8154
Skewness	-0.13774034
Sum	4.8315019 × 10⁸
Variance	1.2905047 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2422256	1	0.5%
2416834	1	0.5%
2434313	1	0.5%
2485798	1	0.5%
2445585	1	0.5%
2445586	1	0.5%
2445587	1	0.5%
2445589	1	0.5%
2445590	1	0.5%
2445592	1	0.5%
Other values (188)	188	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2320579	1	0.5%
2320580	1	0.5%
2320581	1	0.5%
2320582	1	0.5%
2320583	1	0.5%
2320584	1	0.5%
2330728	1	0.5%
2374216	1	0.5%
2380846	1	0.5%
2383896	1	0.5%

Value	Count	Frequency (%)
2582368	1	0.5%
2577825	1	0.5%
2574163	1	0.5%
2540849	1	0.5%
2521739	1	0.5%
2513099	1	0.5%
2511946	1	0.5%
2511945	1	0.5%
2508958	1	0.5%
2506986	1	0.5%

id_embedded
Real number (ℝ)

HIGH CORRELATION

Distinct	103
Distinct (%)	52.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55211.939

Minimum	4175
Maximum	69389
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	4175
5-th percentile	19665
Q1	50617
median	59471
Q3	65411.75
95-th percentile	66223.65
Maximum	69389
Range	65214
Interquartile range (IQR)	14794.75

Descriptive statistics

Standard deviation	13956.939
Coefficient of variation (CV)	0.25278843
Kurtosis	2.6724826
Mean	55211.939
Median Absolute Deviation (MAD)	6287
Skewness	-1.7614462
Sum	10931964
Variance	1.9479616 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65758	16	8.1%
49722	10	5.1%
65657	8	4.0%
37928	8	4.0%
57463	8	4.0%
19665	7	3.5%
62484	6	3.0%
63317	6	3.0%
50617	6	3.0%
59307	6	3.0%
Other values (93)	117	59.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4175	1	0.5%
8035	1	0.5%
9538	2	1.0%
12060	1	0.5%
19111	1	0.5%
19665	7	3.5%
24963	1	0.5%
26268	2	1.0%
29511	1	0.5%
37074	1	0.5%

Value	Count	Frequency (%)
69389	1	0.5%
68575	1	0.5%
68144	1	0.5%
67998	1	0.5%
67684	2	1.0%
67439	1	0.5%
67152	1	0.5%
66849	1	0.5%
66233	1	0.5%
66222	1	0.5%

url
Text

UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

Length

Max length	128
Median length	95
Mean length	79.641414
Min length	54

Characters and Unicode

Total characters	15769
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	198 ?
Unique (%)	100.0%

Sample

1st row	https://www.tvmaze.com/episodes/2422256/trudnye-podrostki-realnost-2x16-seria-16
2nd row	https://www.tvmaze.com/episodes/2521739/engineering-reborn-1x03-episode-3
3rd row	https://www.tvmaze.com/episodes/2411105/wanmei-shijie-1x88-episode-88
4th row	https://www.tvmaze.com/episodes/2463633/supreme-god-emperor-1x229-episode-229
5th row	https://www.tvmaze.com/episodes/2330728/against-the-sky-supreme-1x152-episode-152

Value	Count	Frequency (%)
https://www.tvmaze.com/episodes/2422256/trudnye-podrostki-realnost-2x16-seria-16	1	0.5%
https://www.tvmaze.com/episodes/2443693/slepaa-13x127-lovis-rybka	1	0.5%
https://www.tvmaze.com/episodes/2438236/24-stjerners-julekalender-1x09-julekalender	1	0.5%
https://www.tvmaze.com/episodes/2411105/wanmei-shijie-1x88-episode-88	1	0.5%
https://www.tvmaze.com/episodes/2463633/supreme-god-emperor-1x229-episode-229	1	0.5%
https://www.tvmaze.com/episodes/2330728/against-the-sky-supreme-1x152-episode-152	1	0.5%
https://www.tvmaze.com/episodes/2513099/jiu-tian-xuan-di-jue-3x12-episode-104	1	0.5%
https://www.tvmaze.com/episodes/2427754/romance-and-bullets-1x07-episode-7	1	0.5%
https://www.tvmaze.com/episodes/2432129/oh-my-assistant-1x04-episode-4	1	0.5%
https://www.tvmaze.com/episodes/2451979/love-alarm-clap-clap-clap-1x01-episode-1	1	0.5%
Other values (188)	188	94.9%

Most occurring characters

Value	Count	Frequency (%)
e	1331	8.4%
-	1202	7.6%
/	990	6.3%
s	978	6.2%
t	960	6.1%
o	846	5.4%
a	676	4.3%
w	675	4.3%
i	621	3.9%
m	590	3.7%
Other values (30)	6900	43.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10801	68.5%
Decimal Number	2182	13.8%
Other Punctuation	1584	10.0%
Dash Punctuation	1202	7.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1331	12.3%
s	978	9.1%
t	960	8.9%
o	846	7.8%
a	676	6.3%
w	675	6.2%
i	621	5.7%
m	590	5.5%
p	586	5.4%
h	449	4.2%
Other values (16)	3089	28.6%

Decimal Number

Value	Count	Frequency (%)
2	413	18.9%
4	376	17.2%
1	287	13.2%
0	233	10.7%
3	204	9.3%
5	195	8.9%
9	147	6.7%
8	127	5.8%
6	112	5.1%
7	88	4.0%

Other Punctuation

Value	Count	Frequency (%)
/	990	62.5%
.	396	25.0%
:	198	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	1202	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10801	68.5%
Common	4968	31.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1331	12.3%
s	978	9.1%
t	960	8.9%
o	846	7.8%
a	676	6.3%
w	675	6.2%
i	621	5.7%
m	590	5.5%
p	586	5.4%
h	449	4.2%
Other values (16)	3089	28.6%

Common

Value	Count	Frequency (%)
-	1202	24.2%
/	990	19.9%
2	413	8.3%
.	396	8.0%
4	376	7.6%
1	287	5.8%
0	233	4.7%
3	204	4.1%
:	198	4.0%
5	195	3.9%
Other values (4)	474	9.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15769	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1331	8.4%
-	1202	7.6%
/	990	6.3%
s	978	6.2%
t	960	6.1%
o	846	5.4%
a	676	4.3%
w	675	4.3%
i	621	3.9%
m	590	3.7%
Other values (30)	6900	43.8%

name
Text

Distinct	171
Distinct (%)	86.4%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

Length

Max length	56
Median length	33
Mean length	16.353535
Min length	3

Characters and Unicode

Total characters	3238
Distinct characters	117
Distinct categories	11 ?
Distinct scripts	4 ?
Distinct blocks	6 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	155 ?
Unique (%)	78.3%

Sample

1st row	Серия 16
2nd row	Episode 3
3rd row	Episode 88
4th row	Episode 229
5th row	Episode 152

Value	Count	Frequency (%)
episode	59	9.9%
the	35	5.9%
	20	3.4%
of	11	1.8%
christmas	6	1.0%
a	6	1.0%
16	5	0.8%
7	5	0.8%
5	5	0.8%
10	4	0.7%
Other values (369)	441	73.9%

Most occurring characters

Value	Count	Frequency (%)
	399	12.3%
e	299	9.2%
o	203	6.3%
i	177	5.5%
a	175	5.4%
s	165	5.1%
n	142	4.4%
r	135	4.2%
t	124	3.8%
d	115	3.6%
Other values (107)	1304	40.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2164	66.8%
Uppercase Letter	468	14.5%
Space Separator	399	12.3%
Decimal Number	136	4.2%
Other Punctuation	51	1.6%
Other Letter	6	0.2%
Dash Punctuation	4	0.1%
Close Punctuation	4	0.1%
Open Punctuation	4	0.1%
Other Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	299	13.8%
o	203	9.4%
i	177	8.2%
a	175	8.1%
s	165	7.6%
n	142	6.6%
r	135	6.2%
t	124	5.7%
d	115	5.3%
l	99	4.6%
Other values (36)	530	24.5%

Uppercase Letter

Value	Count	Frequency (%)
E	69	14.7%
T	42	9.0%
C	39	8.3%
S	29	6.2%
B	26	5.6%
M	25	5.3%
P	22	4.7%
D	21	4.5%
F	20	4.3%
W	19	4.1%
Other values (29)	156	33.3%

Decimal Number

Value	Count	Frequency (%)
1	34	25.0%
2	26	19.1%
4	10	7.4%
7	10	7.4%
6	10	7.4%
8	10	7.4%
5	10	7.4%
9	9	6.6%
3	9	6.6%
0	8	5.9%

Other Punctuation

Value	Count	Frequency (%)
'	13	25.5%
/	10	19.6%
&	8	15.7%
.	6	11.8%
,	5	9.8%
?	3	5.9%
!	3	5.9%
:	2	3.9%
…	1	2.0%

Other Letter

Value	Count	Frequency (%)
ل	2	33.3%
ا	1	16.7%
ح	1	16.7%
ق	1	16.7%
ة	1	16.7%

Close Punctuation

Value	Count	Frequency (%)
)	3	75.0%
]	1	25.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	75.0%
[	1	25.0%

Space Separator

Value	Count	Frequency (%)
	399	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Other Symbol

Value	Count	Frequency (%)
№	1	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2577	79.6%
Common	600	18.5%
Cyrillic	55	1.7%
Arabic	6	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	299	11.6%
o	203	7.9%
i	177	6.9%
a	175	6.8%
s	165	6.4%
n	142	5.5%
r	135	5.2%
t	124	4.8%
d	115	4.5%
l	99	3.8%
Other values (45)	943	36.6%

Cyrillic

Value	Count	Frequency (%)
А	6	10.9%
и	4	7.3%
р	3	5.5%
Р	3	5.5%
Е	3	5.5%
о	3	5.5%
к	2	3.6%
т	2	3.6%
б	2	3.6%
К	2	3.6%
Other values (20)	25	45.5%

Common

Value	Count	Frequency (%)
	399	66.5%
1	34	5.7%
2	26	4.3%
'	13	2.2%
/	10	1.7%
4	10	1.7%
7	10	1.7%
6	10	1.7%
8	10	1.7%
5	10	1.7%
Other values (17)	68	11.3%

Arabic

Value	Count	Frequency (%)
ل	2	33.3%
ا	1	16.7%
ح	1	16.7%
ق	1	16.7%
ة	1	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3169	97.9%
Cyrillic	55	1.7%
Arabic	6	0.2%
None	5	0.2%
Punctuation	2	0.1%
Letterlike Symbols	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	399	12.6%
e	299	9.4%
o	203	6.4%
i	177	5.6%
a	175	5.5%
s	165	5.2%
n	142	4.5%
r	135	4.3%
t	124	3.9%
d	115	3.6%
Other values (64)	1235	39.0%

Cyrillic

Value	Count	Frequency (%)
А	6	10.9%
и	4	7.3%
р	3	5.5%
Р	3	5.5%
Е	3	5.5%
о	3	5.5%
к	2	3.6%
т	2	3.6%
б	2	3.6%
К	2	3.6%
Other values (20)	25	45.5%

Arabic

Value	Count	Frequency (%)
ل	2	33.3%
ا	1	16.7%
ح	1	16.7%
ق	1	16.7%
ة	1	16.7%

None

Value	Count	Frequency (%)
ü	1	20.0%
ç	1	20.0%
ë	1	20.0%
é	1	20.0%
æ	1	20.0%

Letterlike Symbols

Value	Count	Frequency (%)
№	1	100.0%

Punctuation

Value	Count	Frequency (%)
…	1	50.0%
’	1	50.0%

season
Real number (ℝ)

HIGH CORRELATION

Distinct	14
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.39899

Minimum	1
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	3.75
95-th percentile	23.75
Maximum	2022
Range	2021
Interquartile range (IQR)	2.75

Descriptive statistics

Standard deviation	421.71726
Coefficient of variation (CV)	4.4673917
Kurtosis	17.514292
Mean	94.39899
Median Absolute Deviation (MAD)	0.5
Skewness	4.3972658
Sum	18691
Variance	177845.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
1	99	50.0%
2	36	18.2%
4	20	10.1%
3	13	6.6%
5	11	5.6%
2022	9	4.5%
13	2	1.0%
7	2	1.0%
28	1	0.5%
14	1	0.5%
Other values (4)	4	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	99	50.0%
2	36	18.2%
3	13	6.6%
4	20	10.1%
5	11	5.6%
7	2	1.0%
9	1	0.5%
12	1	0.5%
13	2	1.0%
14	1	0.5%

Value	Count	Frequency (%)
2022	9	4.5%
28	1	0.5%
23	1	0.5%
22	1	0.5%
14	1	0.5%
13	2	1.0%
12	1	0.5%
9	1	0.5%
7	2	1.0%
5	11	5.6%

number
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	43
Distinct (%)	21.9%
Missing	2
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.030612

Minimum	1
Maximum	246
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	12.25
95-th percentile	79.5
Maximum	246
Range	245
Interquartile range (IQR)	8.25

Descriptive statistics

Standard deviation	33.423607
Coefficient of variation (CV)	1.9625605
Kurtosis	21.685408
Mean	17.030612
Median Absolute Deviation (MAD)	4
Skewness	4.3158818
Sum	3338
Variance	1117.1375
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
5	17	8.6%
6	17	8.6%
8	17	8.6%
4	15	7.6%
2	14	7.1%
3	14	7.1%
1	14	7.1%
7	12	6.1%
9	9	4.5%
10	7	3.5%
Other values (33)	60	30.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14	7.1%
2	14	7.1%
3	14	7.1%
4	15	7.6%
5	17	8.6%
6	17	8.6%
7	12	6.1%
8	17	8.6%
9	9	4.5%
10	7	3.5%

Value	Count	Frequency (%)
246	1	0.5%
229	1	0.5%
152	1	0.5%
139	1	0.5%
128	1	0.5%
127	1	0.5%
115	1	0.5%
90	1	0.5%
88	1	0.5%
87	1	0.5%

type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

regular	196
insignificant_special	1
significant_special	1

Length

Max length	21
Median length	7
Mean length	7.1313131
Min length	7

Characters and Unicode

Total characters	1412
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	1.0%

Sample

1st row	regular
2nd row	regular
3rd row	regular
4th row	regular
5th row	regular

Common Values

Value	Count	Frequency (%)
regular	196	99.0%
insignificant_special	1	0.5%
significant_special	1	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
regular	196	99.0%
insignificant_special	1	0.5%
significant_special	1	0.5%

Most occurring characters

Value	Count	Frequency (%)
r	392	27.8%
a	200	14.2%
e	198	14.0%
g	198	14.0%
l	198	14.0%
u	196	13.9%
i	9	0.6%
n	5	0.4%
s	4	0.3%
c	4	0.3%
Other values (4)	8	0.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1410	99.9%
Connector Punctuation	2	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	392	27.8%
a	200	14.2%
e	198	14.0%
g	198	14.0%
l	198	14.0%
u	196	13.9%
i	9	0.6%
n	5	0.4%
s	4	0.3%
c	4	0.3%
Other values (3)	6	0.4%

Connector Punctuation

Value	Count	Frequency (%)
_	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1410	99.9%
Common	2	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	392	27.8%
a	200	14.2%
e	198	14.0%
g	198	14.0%
l	198	14.0%
u	196	13.9%
i	9	0.6%
n	5	0.4%
s	4	0.3%
c	4	0.3%
Other values (3)	6	0.4%

Common

Value	Count	Frequency (%)
_	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1412	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	392	27.8%
a	200	14.2%
e	198	14.0%
g	198	14.0%
l	198	14.0%
u	196	13.9%
i	9	0.6%
n	5	0.4%
s	4	0.3%
c	4	0.3%
Other values (4)	8	0.6%

airdate
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

2022-12-09	198

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1980
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2022-12-09
2nd row	2022-12-09
3rd row	2022-12-09
4th row	2022-12-09
5th row	2022-12-09

Common Values

Value	Count	Frequency (%)
2022-12-09	198	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022-12-09	198	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	792	40.0%
0	396	20.0%
-	396	20.0%
1	198	10.0%
9	198	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1584	80.0%
Dash Punctuation	396	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	792	50.0%
0	396	25.0%
1	198	12.5%
9	198	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	396	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1980	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	792	40.0%
0	396	20.0%
-	396	20.0%
1	198	10.0%
9	198	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1980	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	792	40.0%
0	396	20.0%
-	396	20.0%
1	198	10.0%
9	198	10.0%

airtime
Categorical

HIGH CORRELATION IMBALANCE

Distinct	22
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

	169
10:00	4
11:30	2
03:00	2
06:00	2
Other values (17)	19

Length

Max length	5
Median length	0
Mean length	0.73232323
Min length	0

Characters and Unicode

Total characters	145
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	7.6%

Sample

1st row
2nd row
3rd row	10:00
4th row	10:00
5th row	10:00

Common Values

Value	Count	Frequency (%)
	169	85.4%
10:00	4	2.0%
11:30	2	1.0%
03:00	2	1.0%
06:00	2	1.0%
17:35	2	1.0%
16:00	2	1.0%
08:30	1	0.5%
12:00	1	0.5%
07:00	1	0.5%
Other values (12)	12	6.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
10:00	4	13.8%
03:00	2	6.9%
06:00	2	6.9%
17:35	2	6.9%
16:00	2	6.9%
11:30	2	6.9%
11:00	1	3.4%
22:30	1	3.4%
19:25	1	3.4%
17:00	1	3.4%
Other values (11)	11	37.9%

Most occurring characters

Value	Count	Frequency (%)
0	56	38.6%
:	29	20.0%
1	23	15.9%
3	9	6.2%
2	7	4.8%
5	6	4.1%
6	4	2.8%
7	4	2.8%
8	3	2.1%
9	3	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	116	80.0%
Other Punctuation	29	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	56	48.3%
1	23	19.8%
3	9	7.8%
2	7	6.0%
5	6	5.2%
6	4	3.4%
7	4	3.4%
8	3	2.6%
9	3	2.6%
4	1	0.9%

Other Punctuation

Value	Count	Frequency (%)
:	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	145	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	56	38.6%
:	29	20.0%
1	23	15.9%
3	9	6.2%
2	7	4.8%
5	6	4.1%
6	4	2.8%
7	4	2.8%
8	3	2.1%
9	3	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	145	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	56	38.6%
:	29	20.0%
1	23	15.9%
3	9	6.2%
2	7	4.8%
5	6	4.1%
6	4	2.8%
7	4	2.8%
8	3	2.1%
9	3	2.1%

airstamp
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

2022-12-09T12:00:00+00:00	123
2022-12-09T17:00:00+00:00	25
2022-12-09T04:00:00+00:00	11
2022-12-09T07:00:00+00:00	4
2022-12-09T02:00:00+00:00	4
Other values (20)	31

Length

Max length	25
Median length	25
Mean length	25
Min length	25

Characters and Unicode

Total characters	4950
Distinct characters	14
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	5.6%

Sample

1st row	2022-12-09T00:00:00+00:00
2nd row	2022-12-09T01:00:00+00:00
3rd row	2022-12-09T02:00:00+00:00
4th row	2022-12-09T02:00:00+00:00
5th row	2022-12-09T02:00:00+00:00

Common Values

Value	Count	Frequency (%)
2022-12-09T12:00:00+00:00	123	62.1%
2022-12-09T17:00:00+00:00	25	12.6%
2022-12-09T04:00:00+00:00	11	5.6%
2022-12-09T07:00:00+00:00	4	2.0%
2022-12-09T02:00:00+00:00	4	2.0%
2022-12-09T09:00:00+00:00	3	1.5%
2022-12-09T03:00:00+00:00	3	1.5%
2022-12-10T02:00:00+00:00	2	1.0%
2022-12-09T03:30:00+00:00	2	1.0%
2022-12-09T05:35:00+00:00	2	1.0%
Other values (15)	19	9.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-12-09t12:00:00+00:00	123	62.1%
2022-12-09t17:00:00+00:00	25	12.6%
2022-12-09t04:00:00+00:00	11	5.6%
2022-12-09t07:00:00+00:00	4	2.0%
2022-12-09t02:00:00+00:00	4	2.0%
2022-12-09t09:00:00+00:00	3	1.5%
2022-12-09t03:00:00+00:00	3	1.5%
2022-12-09t05:00:00+00:00	2	1.0%
2022-12-09t16:00:00+00:00	2	1.0%
2022-12-09t13:30:00+00:00	2	1.0%
Other values (15)	19	9.6%

Most occurring characters

Value	Count	Frequency (%)
0	2004	40.5%
2	922	18.6%
:	594	12.0%
-	396	8.0%
1	366	7.4%
9	198	4.0%
T	198	4.0%
+	198	4.0%
7	29	0.6%
3	17	0.3%
Other values (4)	28	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3564	72.0%
Other Punctuation	594	12.0%
Dash Punctuation	396	8.0%
Uppercase Letter	198	4.0%
Math Symbol	198	4.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2004	56.2%
2	922	25.9%
1	366	10.3%
9	198	5.6%
7	29	0.8%
3	17	0.5%
4	12	0.3%
5	10	0.3%
6	5	0.1%
8	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
:	594	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	396	100.0%

Uppercase Letter

Value	Count	Frequency (%)
T	198	100.0%

Math Symbol

Value	Count	Frequency (%)
+	198	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4752	96.0%
Latin	198	4.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2004	42.2%
2	922	19.4%
:	594	12.5%
-	396	8.3%
1	366	7.7%
9	198	4.2%
+	198	4.2%
7	29	0.6%
3	17	0.4%
4	12	0.3%
Other values (3)	16	0.3%

Latin

Value	Count	Frequency (%)
T	198	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4950	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2004	40.5%
2	922	18.6%
:	594	12.0%
-	396	8.0%
1	366	7.4%
9	198	4.0%
T	198	4.0%
+	198	4.0%
7	29	0.6%
3	17	0.3%
Other values (4)	28	0.6%

runtime
Real number (ℝ)

MISSING

Distinct	58
Distinct (%)	30.7%
Missing	9
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	32.492063

Minimum	1
Maximum	120
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1
5-th percentile	9.4
Q1	21
median	30
Q3	45
95-th percentile	61.6
Maximum	120
Range	119
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	17.806172
Coefficient of variation (CV)	0.54801605
Kurtosis	3.9578491
Mean	32.492063
Median Absolute Deviation (MAD)	12
Skewness	1.298286
Sum	6141
Variance	317.05978
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45	23	11.6%
30	16	8.1%
22	12	6.1%
10	8	4.0%
26	8	4.0%
25	7	3.5%
15	7	3.5%
21	6	3.0%
20	6	3.0%
24	6	3.0%
Other values (48)	90	45.5%
(Missing)	9	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.5%
4	1	0.5%
5	2	1.0%
6	2	1.0%
7	1	0.5%
8	1	0.5%
9	2	1.0%
10	8	4.0%
11	1	0.5%
12	2	1.0%

Value	Count	Frequency (%)
120	1	0.5%
112	1	0.5%
77	1	0.5%
71	2	1.0%
70	1	0.5%
69	1	0.5%
68	2	1.0%
62	1	0.5%
61	1	0.5%
59	1	0.5%

rating_average
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	198
Missing (%)	100.0%
Memory size	1.7 KiB

medium
Text

MISSING

Distinct	104
Distinct (%)	100.0%
Missing	94
Missing (%)	47.5%
Memory size	1.7 KiB

Length

Max length	73
Median length	73
Mean length	73
Min length	73

Characters and Unicode

Total characters	7592
Distinct characters	32
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	104 ?
Unique (%)	100.0%

Sample

1st row	https://static.tvmaze.com/uploads/images/medium_landscape/433/1084747.jpg
2nd row	https://static.tvmaze.com/uploads/images/medium_landscape/457/1143998.jpg
3rd row	https://static.tvmaze.com/uploads/images/medium_landscape/434/1085002.jpg
4th row	https://static.tvmaze.com/uploads/images/medium_landscape/434/1085003.jpg
5th row	https://static.tvmaze.com/uploads/images/medium_landscape/434/1085013.jpg

Value	Count	Frequency (%)
https://static.tvmaze.com/uploads/images/medium_landscape/466/1167001.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1085369.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/457/1143998.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1085002.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1085003.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1085013.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1085187.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1085012.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1086606.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/medium_landscape/434/1086605.jpg	1	1.0%
Other values (94)	94	90.4%

Most occurring characters

Value	Count	Frequency (%)
/	728	9.6%
a	624	8.2%
t	520	6.8%
s	520	6.8%
m	520	6.8%
p	416	5.5%
e	416	5.5%
i	312	4.1%
c	312	4.1%
.	312	4.1%
Other values (22)	2912	38.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5304	69.9%
Other Punctuation	1144	15.1%
Decimal Number	1040	13.7%
Connector Punctuation	104	1.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	624	11.8%
t	520	9.8%
s	520	9.8%
m	520	9.8%
p	416	7.8%
e	416	7.8%
i	312	5.9%
c	312	5.9%
d	312	5.9%
l	208	3.9%
Other values (8)	1144	21.6%

Decimal Number

Value	Count	Frequency (%)
4	205	19.7%
3	172	16.5%
1	161	15.5%
0	137	13.2%
8	124	11.9%
9	66	6.3%
5	60	5.8%
6	49	4.7%
7	42	4.0%
2	24	2.3%

Other Punctuation

Value	Count	Frequency (%)
/	728	63.6%
.	312	27.3%
:	104	9.1%

Connector Punctuation

Value	Count	Frequency (%)
_	104	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5304	69.9%
Common	2288	30.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	624	11.8%
t	520	9.8%
s	520	9.8%
m	520	9.8%
p	416	7.8%
e	416	7.8%
i	312	5.9%
c	312	5.9%
d	312	5.9%
l	208	3.9%
Other values (8)	1144	21.6%

Common

Value	Count	Frequency (%)
/	728	31.8%
.	312	13.6%
4	205	9.0%
3	172	7.5%
1	161	7.0%
0	137	6.0%
8	124	5.4%
_	104	4.5%
:	104	4.5%
9	66	2.9%
Other values (4)	175	7.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	728	9.6%
a	624	8.2%
t	520	6.8%
s	520	6.8%
m	520	6.8%
p	416	5.5%
e	416	5.5%
i	312	4.1%
c	312	4.1%
.	312	4.1%
Other values (22)	2912	38.4%

original
Text

MISSING

Distinct	104
Distinct (%)	100.0%
Missing	94
Missing (%)	47.5%
Memory size	1.7 KiB

Length

Max length	75
Median length	75
Mean length	75
Min length	75

Characters and Unicode

Total characters	7800
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	104 ?
Unique (%)	100.0%

Sample

1st row	https://static.tvmaze.com/uploads/images/original_untouched/433/1084747.jpg
2nd row	https://static.tvmaze.com/uploads/images/original_untouched/457/1143998.jpg
3rd row	https://static.tvmaze.com/uploads/images/original_untouched/434/1085002.jpg
4th row	https://static.tvmaze.com/uploads/images/original_untouched/434/1085003.jpg
5th row	https://static.tvmaze.com/uploads/images/original_untouched/434/1085013.jpg

Value	Count	Frequency (%)
https://static.tvmaze.com/uploads/images/original_untouched/466/1167001.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1085369.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/457/1143998.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1085002.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1085003.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1085013.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1085187.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1085012.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1086606.jpg	1	1.0%
https://static.tvmaze.com/uploads/images/original_untouched/434/1086605.jpg	1	1.0%
Other values (94)	94	90.4%

Most occurring characters

Value	Count	Frequency (%)
/	728	9.3%
t	624	8.0%
a	520	6.7%
s	416	5.3%
i	416	5.3%
o	416	5.3%
p	312	4.0%
c	312	4.0%
.	312	4.0%
g	312	4.0%
Other values (23)	3432	44.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5512	70.7%
Other Punctuation	1144	14.7%
Decimal Number	1040	13.3%
Connector Punctuation	104	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	624	11.3%
a	520	9.4%
s	416	7.5%
i	416	7.5%
o	416	7.5%
p	312	5.7%
c	312	5.7%
g	312	5.7%
m	312	5.7%
e	312	5.7%
Other values (9)	1560	28.3%

Decimal Number

Value	Count	Frequency (%)
4	205	19.7%
3	172	16.5%
1	161	15.5%
0	137	13.2%
8	124	11.9%
9	66	6.3%
5	60	5.8%
6	49	4.7%
7	42	4.0%
2	24	2.3%

Other Punctuation

Value	Count	Frequency (%)
/	728	63.6%
.	312	27.3%
:	104	9.1%

Connector Punctuation

Value	Count	Frequency (%)
_	104	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5512	70.7%
Common	2288	29.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	624	11.3%
a	520	9.4%
s	416	7.5%
i	416	7.5%
o	416	7.5%
p	312	5.7%
c	312	5.7%
g	312	5.7%
m	312	5.7%
e	312	5.7%
Other values (9)	1560	28.3%

Common

Value	Count	Frequency (%)
/	728	31.8%
.	312	13.6%
4	205	9.0%
3	172	7.5%
1	161	7.0%
0	137	6.0%
8	124	5.4%
:	104	4.5%
_	104	4.5%
9	66	2.9%
Other values (4)	175	7.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	728	9.3%
t	624	8.0%
a	520	6.7%
s	416	5.3%
i	416	5.3%
o	416	5.3%
p	312	4.0%
c	312	4.0%
.	312	4.0%
g	312	4.0%
Other values (23)	3432	44.0%

_links_self
Text

UNIQUE

Distinct	198
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

Length

Max length	39
Median length	39
Mean length	39
Min length	39

Characters and Unicode

Total characters	7722
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	198 ?
Unique (%)	100.0%

Sample

1st row	https://api.tvmaze.com/episodes/2422256
2nd row	https://api.tvmaze.com/episodes/2521739
3rd row	https://api.tvmaze.com/episodes/2411105
4th row	https://api.tvmaze.com/episodes/2463633
5th row	https://api.tvmaze.com/episodes/2330728

Value	Count	Frequency (%)
https://api.tvmaze.com/episodes/2422256	1	0.5%
https://api.tvmaze.com/episodes/2443693	1	0.5%
https://api.tvmaze.com/episodes/2438236	1	0.5%
https://api.tvmaze.com/episodes/2411105	1	0.5%
https://api.tvmaze.com/episodes/2463633	1	0.5%
https://api.tvmaze.com/episodes/2330728	1	0.5%
https://api.tvmaze.com/episodes/2513099	1	0.5%
https://api.tvmaze.com/episodes/2427754	1	0.5%
https://api.tvmaze.com/episodes/2432129	1	0.5%
https://api.tvmaze.com/episodes/2451979	1	0.5%
Other values (188)	188	94.9%

Most occurring characters

Value	Count	Frequency (%)
/	792	10.3%
p	594	7.7%
s	594	7.7%
e	594	7.7%
t	594	7.7%
o	396	5.1%
a	396	5.1%
i	396	5.1%
.	396	5.1%
m	396	5.1%
Other values (16)	2574	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4950	64.1%
Other Punctuation	1386	17.9%
Decimal Number	1386	17.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	594	12.0%
s	594	12.0%
e	594	12.0%
t	594	12.0%
o	396	8.0%
a	396	8.0%
i	396	8.0%
m	396	8.0%
h	198	4.0%
d	198	4.0%
Other values (3)	594	12.0%

Decimal Number

Value	Count	Frequency (%)
4	322	23.2%
2	272	19.6%
3	155	11.2%
5	150	10.8%
9	111	8.0%
8	89	6.4%
1	83	6.0%
6	78	5.6%
0	68	4.9%
7	58	4.2%

Other Punctuation

Value	Count	Frequency (%)
/	792	57.1%
.	396	28.6%
:	198	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4950	64.1%
Common	2772	35.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	792	28.6%
.	396	14.3%
4	322	11.6%
2	272	9.8%
:	198	7.1%
3	155	5.6%
5	150	5.4%
9	111	4.0%
8	89	3.2%
1	83	3.0%
Other values (3)	204	7.4%

Latin

Value	Count	Frequency (%)
p	594	12.0%
s	594	12.0%
e	594	12.0%
t	594	12.0%
o	396	8.0%
a	396	8.0%
i	396	8.0%
m	396	8.0%
h	198	4.0%
d	198	4.0%
Other values (3)	594	12.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7722	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	792	10.3%
p	594	7.7%
s	594	7.7%
e	594	7.7%
t	594	7.7%
o	396	5.1%
a	396	5.1%
i	396	5.1%
.	396	5.1%
m	396	5.1%
Other values (16)	2574	33.3%

_links_show
Text

Distinct	103
Distinct (%)	52.0%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

Length

Max length	34
Median length	34
Mean length	33.979798
Min length	33

Characters and Unicode

Total characters	6728
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	76 ?
Unique (%)	38.4%

Sample

1st row	https://api.tvmaze.com/shows/59071
2nd row	https://api.tvmaze.com/shows/67998
3rd row	https://api.tvmaze.com/shows/54894
4th row	https://api.tvmaze.com/shows/55019
5th row	https://api.tvmaze.com/shows/62143

Value	Count	Frequency (%)
https://api.tvmaze.com/shows/65758	16	8.1%
https://api.tvmaze.com/shows/49722	10	5.1%
https://api.tvmaze.com/shows/65657	8	4.0%
https://api.tvmaze.com/shows/37928	8	4.0%
https://api.tvmaze.com/shows/57463	8	4.0%
https://api.tvmaze.com/shows/19665	7	3.5%
https://api.tvmaze.com/shows/50617	6	3.0%
https://api.tvmaze.com/shows/59307	6	3.0%
https://api.tvmaze.com/shows/65851	6	3.0%
https://api.tvmaze.com/shows/63317	6	3.0%
Other values (93)	117	59.1%

Most occurring characters

Value	Count	Frequency (%)
/	792	11.8%
s	594	8.8%
t	594	8.8%
h	396	5.9%
p	396	5.9%
a	396	5.9%
o	396	5.9%
.	396	5.9%
m	396	5.9%
e	198	2.9%
Other values (16)	2174	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4356	64.7%
Other Punctuation	1386	20.6%
Decimal Number	986	14.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	594	13.6%
t	594	13.6%
h	396	9.1%
p	396	9.1%
a	396	9.1%
o	396	9.1%
m	396	9.1%
e	198	4.5%
w	198	4.5%
c	198	4.5%
Other values (3)	594	13.6%

Decimal Number

Value	Count	Frequency (%)
6	169	17.1%
5	168	17.0%
7	102	10.3%
8	89	9.0%
4	89	9.0%
9	84	8.5%
3	82	8.3%
2	77	7.8%
1	74	7.5%
0	52	5.3%

Other Punctuation

Value	Count	Frequency (%)
/	792	57.1%
.	396	28.6%
:	198	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4356	64.7%
Common	2372	35.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	792	33.4%
.	396	16.7%
:	198	8.3%
6	169	7.1%
5	168	7.1%
7	102	4.3%
8	89	3.8%
4	89	3.8%
9	84	3.5%
3	82	3.5%
Other values (3)	203	8.6%

Latin

Value	Count	Frequency (%)
s	594	13.6%
t	594	13.6%
h	396	9.1%
p	396	9.1%
a	396	9.1%
o	396	9.1%
m	396	9.1%
e	198	4.5%
w	198	4.5%
c	198	4.5%
Other values (3)	594	13.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6728	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	792	11.8%
s	594	8.8%
t	594	8.8%
h	396	5.9%
p	396	5.9%
a	396	5.9%
o	396	5.9%
.	396	5.9%
m	396	5.9%
e	198	2.9%
Other values (16)	2174	32.3%

summary
Text

MISSING

Distinct	113
Distinct (%)	100.0%
Missing	85
Missing (%)	42.9%
Memory size	1.7 KiB

Length

Max length	706
Median length	210
Mean length	175.38053
Min length	36

Characters and Unicode

Total characters	19818
Distinct characters	78
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	113 ?
Unique (%)	100.0%

Sample

1st row	<p>An old and deserted dry dock is transformed into an amazing subterranean museum, after the engineers drain the entire ground and build a new concrete base.</p>
2nd row	<p>Both Seon Heo and Mu Yeong have become distressed following their accidental kiss that one night. How will the two of them resolve their embarrassment?</p>
3rd row	<p>Irfan fires at Koko, Asim and Keleshi, starting a war. Nasra wants to stop Bæbs, who are out of money and pushed to the limit. Now everything must be decided.</p>
4th row	<p>Christmas calendar about Christmas calendars! Famous Christmas calendar faces appear to test the participants' knowledge of Christmas calendars on TV.</p>
5th row	<p>It's a dream come true for lifelong superfan Sandra when she meets her idols for the first time—and even performs with them.</p>

Value	Count	Frequency (%)
the	165	5.0%
to	142	4.3%
a	129	3.9%
and	102	3.1%
of	60	1.8%
her	47	1.4%
for	44	1.3%
with	40	1.2%
in	35	1.1%
their	33	1.0%
Other values (1541)	2504	75.9%

Most occurring characters

Value	Count	Frequency (%)
	3187	16.1%
e	1861	9.4%
t	1325	6.7%
a	1266	6.4%
i	1065	5.4%
o	1059	5.3%
s	1018	5.1%
n	1005	5.1%
r	975	4.9%
h	794	4.0%
Other values (68)	6263	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14898	75.2%
Space Separator	3190	16.1%
Uppercase Letter	641	3.2%
Other Punctuation	552	2.8%
Math Symbol	460	2.3%
Dash Punctuation	49	0.2%
Decimal Number	21	0.1%
Open Punctuation	3	< 0.1%
Close Punctuation	3	< 0.1%
Currency Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1861	12.5%
t	1325	8.9%
a	1266	8.5%
i	1065	7.1%
o	1059	7.1%
s	1018	6.8%
n	1005	6.7%
r	975	6.5%
h	794	5.3%
l	588	3.9%
Other values (18)	3942	26.5%

Uppercase Letter

Value	Count	Frequency (%)
A	67	10.5%
S	64	10.0%
T	58	9.0%
M	49	7.6%
C	48	7.5%
B	42	6.6%
L	36	5.6%
H	29	4.5%
W	26	4.1%
R	24	3.7%
Other values (16)	198	30.9%

Other Punctuation

Value	Count	Frequency (%)
.	193	35.0%
,	133	24.1%
/	126	22.8%
'	62	11.2%
?	13	2.4%
!	12	2.2%
"	10	1.8%
:	2	0.4%
;	1	0.2%

Decimal Number

Value	Count	Frequency (%)
0	8	38.1%
1	7	33.3%
8	2	9.5%
2	2	9.5%
5	1	4.8%
9	1	4.8%

Space Separator

Value	Count	Frequency (%)
	3187	99.9%
	3	0.1%

Math Symbol

Value	Count	Frequency (%)
<	230	50.0%
>	230	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	38	77.6%
—	11	22.4%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15539	78.4%
Common	4279	21.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1861	12.0%
t	1325	8.5%
a	1266	8.1%
i	1065	6.9%
o	1059	6.8%
s	1018	6.6%
n	1005	6.5%
r	975	6.3%
h	794	5.1%
l	588	3.8%
Other values (44)	4583	29.5%

Common

Value	Count	Frequency (%)
	3187	74.5%
<	230	5.4%
>	230	5.4%
.	193	4.5%
,	133	3.1%
/	126	2.9%
'	62	1.4%
-	38	0.9%
?	13	0.3%
!	12	0.3%
Other values (14)	55	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19802	99.9%
Punctuation	11	0.1%
None	5	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3187	16.1%
e	1861	9.4%
t	1325	6.7%
a	1266	6.4%
i	1065	5.4%
o	1059	5.3%
s	1018	5.1%
n	1005	5.1%
r	975	4.9%
h	794	4.0%
Other values (64)	6247	31.5%

Punctuation

Value	Count	Frequency (%)
—	11	100.0%

None

Value	Count	Frequency (%)
	3	60.0%
æ	1	20.0%
ë	1	20.0%

Auto

Heatmap
Table

	id	id_embedded	season	number	runtime	type	airtime	airstamp
id	1.000	0.393	-0.025	0.051	-0.043	0.205	0.353	0.403
id_embedded	0.393	1.000	-0.691	-0.050	0.188	0.000	0.317	0.282
season	-0.025	-0.691	1.000	0.029	-0.346	0.000	0.079	0.000
number	0.051	-0.050	0.029	1.000	-0.267	1.000	0.544	0.397
runtime	-0.043	0.188	-0.346	-0.267	1.000	0.153	0.283	0.254
type	0.205	0.000	0.000	1.000	0.153	1.000	0.631	0.000
airtime	0.353	0.317	0.079	0.544	0.283	0.631	1.000	0.826
airstamp	0.403	0.282	0.000	0.397	0.254	0.000	0.826	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	id_embedded	url	name	season	number	type	airdate	airtime	airstamp	runtime	rating_average	medium	original	_links_self	_links_show	summary
0	2422256	59071	https://www.tvmaze.com/episodes/2422256/trudnye-podrostki-realnost-2x16-seria-16	Серия 16	2	16.0	regular	2022-12-09		2022-12-09T00:00:00+00:00	NaN	None	None	None	https://api.tvmaze.com/episodes/2422256	https://api.tvmaze.com/shows/59071	None
1	2521739	67998	https://www.tvmaze.com/episodes/2521739/engineering-reborn-1x03-episode-3	Episode 3	1	3.0	regular	2022-12-09		2022-12-09T01:00:00+00:00	44.0	None	None	None	https://api.tvmaze.com/episodes/2521739	https://api.tvmaze.com/shows/67998	<p>An old and deserted dry dock is transformed into an amazing subterranean museum, after the engineers drain the entire ground and build a new concrete base.</p>
2	2411105	54894	https://www.tvmaze.com/episodes/2411105/wanmei-shijie-1x88-episode-88	Episode 88	1	88.0	regular	2022-12-09	10:00	2022-12-09T02:00:00+00:00	20.0	None	None	None	https://api.tvmaze.com/episodes/2411105	https://api.tvmaze.com/shows/54894	None
3	2463633	55019	https://www.tvmaze.com/episodes/2463633/supreme-god-emperor-1x229-episode-229	Episode 229	1	229.0	regular	2022-12-09	10:00	2022-12-09T02:00:00+00:00	10.0	None	None	None	https://api.tvmaze.com/episodes/2463633	https://api.tvmaze.com/shows/55019	None
4	2330728	62143	https://www.tvmaze.com/episodes/2330728/against-the-sky-supreme-1x152-episode-152	Episode 152	1	152.0	regular	2022-12-09	10:00	2022-12-09T02:00:00+00:00	7.0	None	None	None	https://api.tvmaze.com/episodes/2330728	https://api.tvmaze.com/shows/62143	None
5	2513099	63068	https://www.tvmaze.com/episodes/2513099/jiu-tian-xuan-di-jue-3x12-episode-104	Episode 104	3	12.0	regular	2022-12-09	10:00	2022-12-09T02:00:00+00:00	10.0	None	None	None	https://api.tvmaze.com/episodes/2513099	https://api.tvmaze.com/shows/63068	None
6	2427754	65020	https://www.tvmaze.com/episodes/2427754/romance-and-bullets-1x07-episode-7	Episode 7	1	7.0	regular	2022-12-09		2022-12-09T03:00:00+00:00	24.0	None	None	None	https://api.tvmaze.com/episodes/2427754	https://api.tvmaze.com/shows/65020	None
7	2432129	65213	https://www.tvmaze.com/episodes/2432129/oh-my-assistant-1x04-episode-4	Episode 4	1	4.0	regular	2022-12-09		2022-12-09T03:00:00+00:00	14.0	None	https://static.tvmaze.com/uploads/images/medium_landscape/433/1084747.jpg	https://static.tvmaze.com/uploads/images/original_untouched/433/1084747.jpg	https://api.tvmaze.com/episodes/2432129	https://api.tvmaze.com/shows/65213	<p>Both Seon Heo and Mu Yeong have become distressed following their accidental kiss that one night. How will the two of them resolve their embarrassment?</p>
8	2451979	65897	https://www.tvmaze.com/episodes/2451979/love-alarm-clap-clap-clap-1x01-episode-1	Episode 1	1	1.0	regular	2022-12-09		2022-12-09T03:00:00+00:00	51.0	None	None	None	https://api.tvmaze.com/episodes/2451979	https://api.tvmaze.com/shows/65897	None
9	2458398	66103	https://www.tvmaze.com/episodes/2458398/drawing-jianghu-the-degenerate-1x05-episode-5	Episode 5	1	5.0	regular	2022-12-09	11:30	2022-12-09T03:30:00+00:00	10.0	None	None	None	https://api.tvmaze.com/episodes/2458398	https://api.tvmaze.com/shows/66103	None

	id	id_embedded	url	name	season	number	type	airdate	airtime	airstamp	runtime	rating_average	medium	original	_links_self	_links_show	summary
188	2446132	58739	https://www.tvmaze.com/episodes/2446132/in-with-the-old-3x01-little-weston-cabin	Little Weston Cabin	3	1.0	regular	2022-12-09		2022-12-09T17:00:00+00:00	43.0	None	https://static.tvmaze.com/uploads/images/medium_landscape/437/1094866.jpg	https://static.tvmaze.com/uploads/images/original_untouched/437/1094866.jpg	https://api.tvmaze.com/episodes/2446132	https://api.tvmaze.com/shows/58739	<p>A Connecticut couple renovates a beloved little cabin in Weston.</p>
189	2446133	58739	https://www.tvmaze.com/episodes/2446133/in-with-the-old-3x02-charm-city	Charm City	3	2.0	regular	2022-12-09		2022-12-09T17:00:00+00:00	43.0	None	https://static.tvmaze.com/uploads/images/medium_landscape/437/1094867.jpg	https://static.tvmaze.com/uploads/images/original_untouched/437/1094867.jpg	https://api.tvmaze.com/episodes/2446133	https://api.tvmaze.com/shows/58739	<p>Preserving a historic Baltimore home reveals a unique Civil Rights story.</p>
190	2413725	61086	https://www.tvmaze.com/episodes/2413725/wwe-nxt-level-up-1x43-level-up-43	Level Up 43	1	43.0	regular	2022-12-09		2022-12-09T17:00:00+00:00	30.0	None	None	None	https://api.tvmaze.com/episodes/2413725	https://api.tvmaze.com/shows/61086	None
191	2442199	61129	https://www.tvmaze.com/episodes/2442199/the-craftsman-2x05-an-honest-days-work	An Honest Day’s Work	2	5.0	regular	2022-12-09		2022-12-09T17:00:00+00:00	24.0	None	https://static.tvmaze.com/uploads/images/medium_landscape/438/1097129.jpg	https://static.tvmaze.com/uploads/images/original_untouched/438/1097129.jpg	https://api.tvmaze.com/episodes/2442199	https://api.tvmaze.com/shows/61129	<p>Eric helps a local farmer repair his 100-year-old cider press.</p>
192	2434911	63554	https://www.tvmaze.com/episodes/2434911/firebuds-1x27-call-of-the-siren	Call of the Siren	1	27.0	regular	2022-12-09		2022-12-09T17:00:00+00:00	12.0	None	None	None	https://api.tvmaze.com/episodes/2434911	https://api.tvmaze.com/shows/63554	<p>When Axl uses her siren to part traffic for non-emergencies, she struggles to get the other cars on the road to trust her judgment.</p>
193	2434912	63554	https://www.tvmaze.com/episodes/2434912/firebuds-1x28-jamals-jam	Jamal's Jam	1	28.0	regular	2022-12-09		2022-12-09T17:00:00+00:00	12.0	None	None	None	https://api.tvmaze.com/episodes/2434912	https://api.tvmaze.com/shows/63554	<p>Jayden joins his dad at work.</p>
194	2450219	8035	https://www.tvmaze.com/episodes/2450219/bettys-diagnose-9x12-stunde-der-wahrheit	Stunde der Wahrheit	9	12.0	regular	2022-12-09	19:25	2022-12-09T18:25:00+00:00	45.0	None	None	None	https://api.tvmaze.com/episodes/2450219	https://api.tvmaze.com/shows/8035	None
195	2441922	65408	https://www.tvmaze.com/episodes/2441922/kids-in-crime-1x07-en-finger-i-raeva	En finger i ræva	1	7.0	regular	2022-12-09	03:00	2022-12-10T02:00:00+00:00	21.0	None	None	None	https://api.tvmaze.com/episodes/2441922	https://api.tvmaze.com/shows/65408	None
196	2441923	65408	https://www.tvmaze.com/episodes/2441923/kids-in-crime-1x08-party-time	Party Time	1	8.0	regular	2022-12-09	03:00	2022-12-10T02:00:00+00:00	21.0	None	None	None	https://api.tvmaze.com/episodes/2441923	https://api.tvmaze.com/shows/65408	None
197	2540849	68575	https://www.tvmaze.com/episodes/2540849/mujeres-asesinas-1x06-como-hermanas	Como hermanas	1	6.0	regular	2022-12-09	00:00	2022-12-10T06:00:00+00:00	61.0	None	None	None	https://api.tvmaze.com/episodes/2540849	https://api.tvmaze.com/shows/68575	None

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Other Letter

Close Punctuation

Open Punctuation

Space Separator

Dash Punctuation

Other Symbol

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Cyrillic

Common

Arabic

Most occurring blocks

Most frequent character per block

ASCII

Cyrillic

Arabic

None

Letterlike Symbols

Punctuation

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation